<html><head><title>Add new columns</title><meta name="HandheldFriendly" content="True"></head><body>Add new columns<br><br><b>alter</b> <b>table</b> [database.[owner].]table <b>add</b> {column datatype [<b>default</b> { constant_expression | <b>user</b> | <b>null</b> }] {<b>identity</b> | <b>null</b> | <b>not</b> <b>null</b>} [<b>off</b> <b>row</b> | <b>on</b> <b>row</b>]  [[<b>constraint</b> constraint] {{ <b>unique</b> | <b>primary</b> <b>key</b> } [<b>clustered</b> | <b>nonclustered</b>] [<b>asc</b>|<b>desc</b>] [<a href="q307271.html">index tuning options</a>] [<b>on</b> segment] | <b>references</b>  [[database.]owner.]table [(column)] [<b>match</b> <b>full</b>] | <b>check</b> (search_condition)}]}...} <a href="w109049.html">(repeatable)</a></body></html>